<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
		<head>
			<!-- template designed by Marco Von Ballmoos -->
			<title>File Source for sql.php</title>
			<link rel="stylesheet" href="../media/stylesheet.css" />
			<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/>
		</head>
		<body>
						<h1>Source for file sql.php</h1>
<p>Documentation is available at <a href="../core/_geshi_sql_php.html">sql.php</a></p>
<div class="src-code">
<pre><a name="a1"></a><br />1     <span class="src-php">&lt;?php</span><a name="a2"></a><br />2     <span class="src-doc">/***********************************************************************************</span><a name="a3"></a><br />3     <span class="src-doc"> * sql.php</span><a name="a4"></a><br />4     <span class="src-doc"> * -------</span><a name="a5"></a><br />5     <span class="src-doc"> * Author: Nigel McNie (oracle.shinoda@gmail.com)</span><a name="a6"></a><br />6     <span class="src-doc"> * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)</span><a name="a7"></a><br />7     <span class="src-doc"> * Release Version: 1.0.7.3</span><a name="a8"></a><br />8     <span class="src-doc"> * CVS Revision Version: $Revision: 1.5 $</span><a name="a9"></a><br />9     <span class="src-doc"> * Date Started: 2004/06/04</span><a name="a10"></a><br />10    <span class="src-doc"> * Last Modified: $Date: 2005/09/22 01:41:46 $</span><a name="a11"></a><br />11    <span class="src-doc"> *</span><a name="a12"></a><br />12    <span class="src-doc"> * SQL language file for GeSHi.</span><a name="a13"></a><br />13    <span class="src-doc"> *</span><a name="a14"></a><br />14    <span class="src-doc"> * CHANGES</span><a name="a15"></a><br />15    <span class="src-doc"> * -------</span><a name="a16"></a><br />16    <span class="src-doc"> * 2004/11/27 (1.0.3)</span><a name="a17"></a><br />17    <span class="src-doc"> *  -  Added support for multiple object splitters</span><a name="a18"></a><br />18    <span class="src-doc"> * 2004/10/27 (1.0.2)</span><a name="a19"></a><br />19    <span class="src-doc"> *  -  Added &quot;`&quot; string delimiter</span><a name="a20"></a><br />20    <span class="src-doc"> *  -  Added &quot;#&quot; single comment starter</span><a name="a21"></a><br />21    <span class="src-doc"> * 2004/08/05 (1.0.1)</span><a name="a22"></a><br />22    <span class="src-doc"> *  -  Added support for symbols</span><a name="a23"></a><br />23    <span class="src-doc"> *  -  Added many more keywords (mostly MYSQL keywords)</span><a name="a24"></a><br />24    <span class="src-doc"> * 2004/07/14 (1.0.0)</span><a name="a25"></a><br />25    <span class="src-doc"> *  -  First Release</span><a name="a26"></a><br />26    <span class="src-doc"> *</span><a name="a27"></a><br />27    <span class="src-doc"> * TODO (updated 2004/11/27)</span><a name="a28"></a><br />28    <span class="src-doc"> * -------------------------</span><a name="a29"></a><br />29    <span class="src-doc"> * * Add all keywords</span><a name="a30"></a><br />30    <span class="src-doc"> * * Split this to several sql files - mysql-sql, ansi-sql etc</span><a name="a31"></a><br />31    <span class="src-doc"> *</span><a name="a32"></a><br />32    <span class="src-doc"> ************************************************************************************</span><a name="a33"></a><br />33    <span class="src-doc"> *</span><a name="a34"></a><br />34    <span class="src-doc"> *     This file is part of GeSHi.</span><a name="a35"></a><br />35    <span class="src-doc"> *</span><a name="a36"></a><br />36    <span class="src-doc"> *   GeSHi is free software; you can redistribute it and/or modify</span><a name="a37"></a><br />37    <span class="src-doc"> *   it under the terms of the GNU General Public License as published by</span><a name="a38"></a><br />38    <span class="src-doc"> *   the Free Software Foundation; either version 2 of the License, or</span><a name="a39"></a><br />39    <span class="src-doc"> *   (at your option) any later version.</span><a name="a40"></a><br />40    <span class="src-doc"> *</span><a name="a41"></a><br />41    <span class="src-doc"> *   GeSHi is distributed in the hope that it will be useful,</span><a name="a42"></a><br />42    <span class="src-doc"> *   but WITHOUT ANY WARRANTY; without even the implied warranty of</span><a name="a43"></a><br />43    <span class="src-doc"> *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the</span><a name="a44"></a><br />44    <span class="src-doc"> *   GNU General Public License for more details.</span><a name="a45"></a><br />45    <span class="src-doc"> *</span><a name="a46"></a><br />46    <span class="src-doc"> *   You should have received a copy of the GNU General Public License</span><a name="a47"></a><br />47    <span class="src-doc"> *   along with GeSHi; if not, write to the Free Software</span><a name="a48"></a><br />48    <span class="src-doc"> *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA</span><a name="a49"></a><br />49    <span class="src-doc"> *</span><a name="a50"></a><br />50    <span class="src-doc"> ************************************************************************************/</span><a name="a50"></a><br />50    <a name="a51"></a><br />51    <a name="a52"></a><br />52    <span class="src-var">$language_data</span> = <span class="src-key">array</span> <span class="src-sym">(</span><a name="a53"></a><br />53        <span class="src-str">'LANG_NAME'</span> =&gt; <span class="src-str">'SQL'</span><span class="src-sym">,</span><a name="a54"></a><br />54        <span class="src-str">'COMMENT_SINGLE'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><span class="src-num">1</span> =&gt;<span class="src-str">'--'</span><span class="src-sym">,</span> <span class="src-num">2</span> =&gt; <span class="src-str">'#'</span><span class="src-sym">)</span><span class="src-sym">,</span><a name="a55"></a><br />55        <span class="src-str">'COMMENT_MULTI'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><span class="src-str">'/*'</span> =&gt; <span class="src-str">'*/'</span><span class="src-sym">)</span><span class="src-sym">,</span><a name="a56"></a><br />56        <span class="src-str">'CASE_KEYWORDS'</span> =&gt; <span class="src-num">1</span><span class="src-sym">,</span><a name="a57"></a><br />57        <span class="src-str">'QUOTEMARKS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><span class="src-str">&quot;'&quot;</span><span class="src-sym">,</span> <span class="src-str">'&quot;'</span><span class="src-sym">,</span> <span class="src-str">'`'</span><span class="src-sym">)</span><span class="src-sym">,</span><a name="a58"></a><br />58        <span class="src-str">'ESCAPE_CHAR'</span> =&gt; <span class="src-str">'\\'</span><span class="src-sym">,</span><a name="a59"></a><br />59        <span class="src-str">'KEYWORDS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a60"></a><br />60            <span class="src-num">1</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a61"></a><br />61                <span class="src-str">'ALL'</span><span class="src-sym">,</span> <span class="src-str">'ASC'</span><span class="src-sym">,</span> <span class="src-str">'AS'</span><span class="src-sym">,</span>  <span class="src-str">'ALTER'</span><span class="src-sym">,</span> <span class="src-str">'AND'</span><span class="src-sym">,</span> <span class="src-str">'ADD'</span><span class="src-sym">,</span> <span class="src-str">'AUTO_INCREMENT'</span><span class="src-sym">,</span><a name="a62"></a><br />62                <span class="src-str">'BETWEEN'</span><span class="src-sym">,</span> <span class="src-str">'BINARY'</span><span class="src-sym">,</span> <span class="src-str">'BOTH'</span><span class="src-sym">,</span> <span class="src-str">'BY'</span><span class="src-sym">,</span> <span class="src-str">'BOOLEAN'</span><span class="src-sym">,</span><a name="a63"></a><br />63                <span class="src-str">'CHANGE'</span><span class="src-sym">,</span> <span class="src-str">'CHECK'</span><span class="src-sym">,</span> <span class="src-str">'COLUMNS'</span><span class="src-sym">,</span> <span class="src-str">'COLUMN'</span><span class="src-sym">,</span> <span class="src-str">'CROSS'</span><span class="src-sym">,</span><span class="src-str">'CREATE'</span><span class="src-sym">,</span><a name="a64"></a><br />64                <span class="src-str">'DATABASES'</span><span class="src-sym">,</span> <span class="src-str">'DATABASE'</span><span class="src-sym">,</span> <span class="src-str">'DATA'</span><span class="src-sym">,</span> <span class="src-str">'DELAYED'</span><span class="src-sym">,</span> <span class="src-str">'DESCRIBE'</span><span class="src-sym">,</span> <span class="src-str">'DESC'</span><span class="src-sym">,</span>  <span class="src-str">'DISTINCT'</span><span class="src-sym">,</span> <span class="src-str">'DELETE'</span><span class="src-sym">,</span> <span class="src-str">'DROP'</span><span class="src-sym">,</span> <span class="src-str">'DEFAULT'</span><span class="src-sym">,</span><a name="a65"></a><br />65                <span class="src-str">'ENCLOSED'</span><span class="src-sym">,</span> <span class="src-str">'ESCAPED'</span><span class="src-sym">,</span> <span class="src-str">'EXISTS'</span><span class="src-sym">,</span> <span class="src-str">'EXPLAIN'</span><span class="src-sym">,</span><a name="a66"></a><br />66                <span class="src-str">'FIELDS'</span><span class="src-sym">,</span> <span class="src-str">'FIELD'</span><span class="src-sym">,</span> <span class="src-str">'FLUSH'</span><span class="src-sym">,</span> <span class="src-str">'FOR'</span><span class="src-sym">,</span> <span class="src-str">'FOREIGN'</span><span class="src-sym">,</span> <span class="src-str">'FUNCTION'</span><span class="src-sym">,</span> <span class="src-str">'FROM'</span><span class="src-sym">,</span><a name="a67"></a><br />67                <span class="src-str">'GROUP'</span><span class="src-sym">,</span> <span class="src-str">'GRANT'</span><span class="src-sym">,</span><a name="a68"></a><br />68                <span class="src-str">'HAVING'</span><span class="src-sym">,</span><a name="a69"></a><br />69                <span class="src-str">'IGNORE'</span><span class="src-sym">,</span> <span class="src-str">'INDEX'</span><span class="src-sym">,</span> <span class="src-str">'INFILE'</span><span class="src-sym">,</span> <span class="src-str">'INSERT'</span><span class="src-sym">,</span> <span class="src-str">'INNER'</span><span class="src-sym">,</span> <span class="src-str">'INTO'</span><span class="src-sym">,</span> <span class="src-str">'IDENTIFIED'</span><span class="src-sym">,</span> <span class="src-str">'IN'</span><span class="src-sym">,</span> <span class="src-str">'IS'</span><span class="src-sym">,</span> <span class="src-str">'IF'</span><span class="src-sym">,</span><a name="a70"></a><br />70                <span class="src-str">'JOIN'</span><span class="src-sym">,</span><a name="a71"></a><br />71                <span class="src-str">'KEYS'</span><span class="src-sym">,</span> <span class="src-str">'KILL'</span><span class="src-sym">,</span><span class="src-str">'KEY'</span><span class="src-sym">,</span><a name="a72"></a><br />72                <span class="src-str">'LEADING'</span><span class="src-sym">,</span> <span class="src-str">'LIKE'</span><span class="src-sym">,</span> <span class="src-str">'LIMIT'</span><span class="src-sym">,</span> <span class="src-str">'LINES'</span><span class="src-sym">,</span> <span class="src-str">'LOAD'</span><span class="src-sym">,</span> <span class="src-str">'LOCAL'</span><span class="src-sym">,</span> <span class="src-str">'LOCK'</span><span class="src-sym">,</span> <span class="src-str">'LOW_PRIORITY'</span><span class="src-sym">,</span> <span class="src-str">'LEFT'</span><span class="src-sym">,</span> <span class="src-str">'LANGUAGE'</span><span class="src-sym">,</span><a name="a73"></a><br />73                <span class="src-str">'MODIFY'</span><span class="src-sym">,</span><a name="a74"></a><br />74                <span class="src-str">'NATURAL'</span><span class="src-sym">,</span> <span class="src-str">'NOT'</span><span class="src-sym">,</span> <span class="src-str">'NULL'</span><span class="src-sym">,</span> <span class="src-str">'NEXTVAL'</span><span class="src-sym">,</span><a name="a75"></a><br />75                <span class="src-str">'OPTIMIZE'</span><span class="src-sym">,</span> <span class="src-str">'OPTION'</span><span class="src-sym">,</span> <span class="src-str">'OPTIONALLY'</span><span class="src-sym">,</span> <span class="src-str">'ORDER'</span><span class="src-sym">,</span> <span class="src-str">'OUTFILE'</span><span class="src-sym">,</span> <span class="src-str">'OR'</span><span class="src-sym">,</span> <span class="src-str">'OUTER'</span><span class="src-sym">,</span> <span class="src-str">'ON'</span><span class="src-sym">,</span><a name="a76"></a><br />76                <span class="src-str">'PROCEEDURE'</span><span class="src-sym">,</span><span class="src-str">'PROCEDURAL'</span><span class="src-sym">,</span> <span class="src-str">'PRIMARY'</span><span class="src-sym">,</span><a name="a77"></a><br />77                <span class="src-str">'READ'</span><span class="src-sym">,</span> <span class="src-str">'REFERENCES'</span><span class="src-sym">,</span> <span class="src-str">'REGEXP'</span><span class="src-sym">,</span> <span class="src-str">'RENAME'</span><span class="src-sym">,</span> <span class="src-str">'REPLACE'</span><span class="src-sym">,</span> <span class="src-str">'RETURN'</span><span class="src-sym">,</span> <span class="src-str">'REVOKE'</span><span class="src-sym">,</span> <span class="src-str">'RLIKE'</span><span class="src-sym">,</span> <span class="src-str">'RIGHT'</span><span class="src-sym">,</span><a name="a78"></a><br />78                <span class="src-str">'SHOW'</span><span class="src-sym">,</span> <span class="src-str">'SONAME'</span><span class="src-sym">,</span> <span class="src-str">'STATUS'</span><span class="src-sym">,</span> <span class="src-str">'STRAIGHT_JOIN'</span><span class="src-sym">,</span> <span class="src-str">'SELECT'</span><span class="src-sym">,</span> <span class="src-str">'SETVAL'</span><span class="src-sym">,</span> <span class="src-str">'SET'</span><span class="src-sym">,</span><a name="a79"></a><br />79                <span class="src-str">'TABLES'</span><span class="src-sym">,</span> <span class="src-str">'TEMINATED'</span><span class="src-sym">,</span> <span class="src-str">'TO'</span><span class="src-sym">,</span> <span class="src-str">'TRAILING'</span><span class="src-sym">,</span><span class="src-str">'TRUNCATE'</span><span class="src-sym">,</span> <span class="src-str">'TABLE'</span><span class="src-sym">,</span> <span class="src-str">'TEMPORARY'</span><span class="src-sym">,</span> <span class="src-str">'TRIGGER'</span><span class="src-sym">,</span> <span class="src-str">'TRUSTED'</span><span class="src-sym">,</span><a name="a80"></a><br />80                <span class="src-str">'UNIQUE'</span><span class="src-sym">,</span> <span class="src-str">'UNLOCK'</span><span class="src-sym">,</span> <span class="src-str">'USE'</span><span class="src-sym">,</span> <span class="src-str">'USING'</span><span class="src-sym">,</span> <span class="src-str">'UPDATE'</span><span class="src-sym">,</span> <span class="src-str">'UNSIGNED'</span><span class="src-sym">,</span><a name="a81"></a><br />81                <span class="src-str">'VALUES'</span><span class="src-sym">,</span> <span class="src-str">'VARIABLES'</span><span class="src-sym">,</span> <span class="src-str">'VIEW'</span><span class="src-sym">,</span><a name="a82"></a><br />82                <span class="src-str">'WITH'</span><span class="src-sym">,</span> <span class="src-str">'WRITE'</span><span class="src-sym">,</span> <span class="src-str">'WHERE'</span><span class="src-sym">,</span><a name="a83"></a><br />83                <span class="src-str">'ZEROFILL'</span><span class="src-sym">,</span><a name="a84"></a><br />84                <span class="src-str">'XOR'</span><span class="src-sym">,</span><a name="a85"></a><br />85                <span class="src-sym">)</span><a name="a86"></a><br />86            <span class="src-sym">)</span><span class="src-sym">,</span><a name="a87"></a><br />87        <span class="src-str">'SYMBOLS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a88"></a><br />88            <span class="src-str">'('</span><span class="src-sym">,</span> <span class="src-str">')'</span><span class="src-sym">,</span> <span class="src-str">'='</span><span class="src-sym">,</span> <span class="src-str">'&lt;'</span><span class="src-sym">,</span> <span class="src-str">'&gt;'</span><span class="src-sym">,</span> <span class="src-str">'|'</span><a name="a89"></a><br />89            <span class="src-sym">)</span><span class="src-sym">,</span><a name="a90"></a><br />90        <span class="src-str">'CASE_SENSITIVE'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a91"></a><br />91            <span class="src-id">GESHI_COMMENTS</span> =&gt; <span class="src-id">false</span><span class="src-sym">,</span><a name="a92"></a><br />92            <span class="src-num">1</span> =&gt; <span class="src-id">false</span><a name="a93"></a><br />93            <span class="src-sym">)</span><span class="src-sym">,</span><a name="a94"></a><br />94        <span class="src-str">'STYLES'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a95"></a><br />95            <span class="src-str">'KEYWORDS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a96"></a><br />96                <span class="src-num">1</span> =&gt; <span class="src-str">'color: #993333; font-weight: bold;'</span><a name="a97"></a><br />97                <span class="src-sym">)</span><span class="src-sym">,</span><a name="a98"></a><br />98            <span class="src-str">'COMMENTS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a99"></a><br />99                <span class="src-num">1</span> =&gt; <span class="src-str">'color: #808080; font-style: italic;'</span><span class="src-sym">,</span><a name="a100"></a><br />100               <span class="src-num">2</span> =&gt; <span class="src-str">'color: #808080; font-style: italic;'</span><a name="a101"></a><br />101               <span class="src-sym">)</span><span class="src-sym">,</span><a name="a102"></a><br />102           <span class="src-str">'ESCAPE_CHAR'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a103"></a><br />103               <span class="src-num">0</span> =&gt; <span class="src-str">'color: #000099; font-weight: bold;'</span><a name="a104"></a><br />104               <span class="src-sym">)</span><span class="src-sym">,</span><a name="a105"></a><br />105           <span class="src-str">'BRACKETS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a106"></a><br />106               <span class="src-num">0</span> =&gt; <span class="src-str">'color: #66cc66;'</span><a name="a107"></a><br />107               <span class="src-sym">)</span><span class="src-sym">,</span><a name="a108"></a><br />108           <span class="src-str">'STRINGS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a109"></a><br />109               <span class="src-num">0</span> =&gt; <span class="src-str">'color: #ff0000;'</span><a name="a110"></a><br />110               <span class="src-sym">)</span><span class="src-sym">,</span><a name="a111"></a><br />111           <span class="src-str">'NUMBERS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a112"></a><br />112               <span class="src-num">0</span> =&gt; <span class="src-str">'color: #cc66cc;'</span><a name="a113"></a><br />113               <span class="src-sym">)</span><span class="src-sym">,</span><a name="a114"></a><br />114           <span class="src-str">'METHODS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a115"></a><br />115               <span class="src-sym">)</span><span class="src-sym">,</span><a name="a116"></a><br />116           <span class="src-str">'SYMBOLS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a117"></a><br />117               <span class="src-num">0</span> =&gt; <span class="src-str">'color: #66cc66;'</span><a name="a118"></a><br />118               <span class="src-sym">)</span><span class="src-sym">,</span><a name="a119"></a><br />119           <span class="src-str">'SCRIPT'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a120"></a><br />120               <span class="src-sym">)</span><span class="src-sym">,</span><a name="a121"></a><br />121           <span class="src-str">'REGEXPS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a122"></a><br />122               <span class="src-sym">)</span><a name="a123"></a><br />123           <span class="src-sym">)</span><span class="src-sym">,</span><a name="a124"></a><br />124       <span class="src-str">'OOLANG'</span> =&gt; <span class="src-id">false</span><span class="src-sym">,</span><a name="a125"></a><br />125       <span class="src-str">'OBJECT_SPLITTERS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a126"></a><br />126           <span class="src-sym">)</span><span class="src-sym">,</span><a name="a127"></a><br />127       <span class="src-str">'REGEXPS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a128"></a><br />128           <span class="src-sym">)</span><span class="src-sym">,</span><a name="a129"></a><br />129       <span class="src-str">'STRICT_MODE_APPLIES'</span> =&gt; <span class="src-id">GESHI_NEVER</span><span class="src-sym">,</span><a name="a130"></a><br />130       <span class="src-str">'SCRIPT_DELIMITERS'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a131"></a><br />131           <span class="src-sym">)</span><span class="src-sym">,</span><a name="a132"></a><br />132       <span class="src-str">'HIGHLIGHT_STRICT_BLOCK'</span> =&gt; <span class="src-key">array</span><span class="src-sym">(</span><a name="a133"></a><br />133           <span class="src-sym">)</span><a name="a134"></a><br />134   <span class="src-sym">)</span>;<a name="a135"></a><br />135   <a name="a136"></a><br />136   <span class="src-php">?&gt;</span></pre>
</div>
	<p class="notes" id="credit">
		Documentation generated on Thu, 22 Sep 2005 13:48:06 +1200 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.2.3</a>
	</p>
	</body>
</html>